﻿<?xml version="1.0" encoding="utf-8"?>
<xs:schema id="dsCommons" targetNamespace="http://tempuri.org/dsCommons.xsd" xmlns:mstns="http://tempuri.org/dsCommons.xsd" xmlns="http://tempuri.org/dsCommons.xsd" xmlns:xs="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:msprop="urn:schemas-microsoft-com:xml-msprop" attributeFormDefault="qualified" elementFormDefault="qualified">
  <xs:annotation>
    <xs:appinfo source="urn:schemas-microsoft-com:xml-msdatasource">
      <DataSource DefaultConnectionIndex="0" FunctionsComponentName="QueriesTableAdapter" Modifier="AutoLayout, AnsiClass, Class, Public" SchemaSerializationMode="IncludeSchema" xmlns="urn:schemas-microsoft-com:xml-msdatasource">
        <Connections>
          <Connection AppSettingsObjectName="Web.config" AppSettingsPropertyName="HDConnectionString" ConnectionStringObject="" IsAppSettingsProperty="true" Modifier="Assembly" Name="HDConnectionString (Web.config)" ParameterPrefix="@" PropertyReference="AppConfig.System.Configuration.ConfigurationManager.0.ConnectionStrings.HDConnectionString.ConnectionString" Provider="System.Data.SqlClient" />
        </Connections>
        <Tables />
        <Sources />
      </DataSource>
    </xs:appinfo>
  </xs:annotation>
  <xs:element name="dsCommons" msdata:IsDataSet="true" msdata:UseCurrentLocale="true" msprop:EnableTableAdapterManager="true" msprop:Generator_DataSetName="dsCommons" msprop:Generator_UserDSName="dsCommons">
    <xs:complexType>
      <xs:choice minOccurs="0" maxOccurs="unbounded">
        <xs:element name="tblOrder" msprop:Generator_TableClassName="tblOrderDataTable" msprop:Generator_TableVarName="tabletblOrder" msprop:Generator_TablePropName="tblOrder" msprop:Generator_RowDeletingName="tblOrderRowDeleting" msprop:Generator_UserTableName="tblOrder" msprop:Generator_RowChangingName="tblOrderRowChanging" msprop:Generator_RowEvHandlerName="tblOrderRowChangeEventHandler" msprop:Generator_RowDeletedName="tblOrderRowDeleted" msprop:Generator_RowEvArgName="tblOrderRowChangeEvent" msprop:Generator_RowChangedName="tblOrderRowChanged" msprop:Generator_RowClassName="tblOrderRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="PK_iOID" msprop:Generator_ColumnVarNameInTable="columnPK_iOID" msprop:Generator_ColumnPropNameInRow="PK_iOID" msprop:Generator_ColumnPropNameInTable="PK_iOIDColumn" msprop:Generator_UserColumnName="PK_iOID" type="xs:int" />
              <xs:element name="FK_iATID" msprop:Generator_ColumnVarNameInTable="columnFK_iATID" msprop:Generator_ColumnPropNameInRow="FK_iATID" msprop:Generator_ColumnPropNameInTable="FK_iATIDColumn" msprop:Generator_UserColumnName="FK_iATID" type="xs:int" minOccurs="0" />
              <xs:element name="FK_iAFID" msprop:Generator_ColumnVarNameInTable="columnFK_iAFID" msprop:Generator_ColumnPropNameInRow="FK_iAFID" msprop:Generator_ColumnPropNameInTable="FK_iAFIDColumn" msprop:Generator_UserColumnName="FK_iAFID" type="xs:int" minOccurs="0" />
              <xs:element name="FK_iASID" msprop:Generator_ColumnVarNameInTable="columnFK_iASID" msprop:Generator_ColumnPropNameInRow="FK_iASID" msprop:Generator_ColumnPropNameInTable="FK_iASIDColumn" msprop:Generator_UserColumnName="FK_iASID" type="xs:int" minOccurs="0" />
              <xs:element name="sFullName" msprop:Generator_ColumnVarNameInTable="columnsFullName" msprop:Generator_ColumnPropNameInRow="sFullName" msprop:Generator_ColumnPropNameInTable="sFullNameColumn" msprop:Generator_UserColumnName="sFullName" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sAddress" msprop:Generator_ColumnVarNameInTable="columnsAddress" msprop:Generator_ColumnPropNameInRow="sAddress" msprop:Generator_ColumnPropNameInTable="sAddressColumn" msprop:Generator_UserColumnName="sAddress" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="100" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sEmail" msprop:Generator_ColumnVarNameInTable="columnsEmail" msprop:Generator_ColumnPropNameInRow="sEmail" msprop:Generator_ColumnPropNameInTable="sEmailColumn" msprop:Generator_UserColumnName="sEmail" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="50" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sPhoneNumber" msprop:Generator_ColumnVarNameInTable="columnsPhoneNumber" msprop:Generator_ColumnPropNameInRow="sPhoneNumber" msprop:Generator_ColumnPropNameInTable="sPhoneNumberColumn" msprop:Generator_UserColumnName="sPhoneNumber" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="20" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sNote" msprop:Generator_ColumnVarNameInTable="columnsNote" msprop:Generator_ColumnPropNameInRow="sNote" msprop:Generator_ColumnPropNameInTable="sNoteColumn" msprop:Generator_UserColumnName="sNote" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="sInfoEx" msprop:Generator_ColumnVarNameInTable="columnsInfoEx" msprop:Generator_ColumnPropNameInRow="sInfoEx" msprop:Generator_ColumnPropNameInTable="sInfoExColumn" msprop:Generator_UserColumnName="sInfoEx" minOccurs="0">
                <xs:simpleType>
                  <xs:restriction base="xs:string">
                    <xs:maxLength value="500" />
                  </xs:restriction>
                </xs:simpleType>
              </xs:element>
              <xs:element name="dTotalPrice" msprop:Generator_ColumnVarNameInTable="columndTotalPrice" msprop:Generator_ColumnPropNameInRow="dTotalPrice" msprop:Generator_ColumnPropNameInTable="dTotalPriceColumn" msprop:Generator_UserColumnName="dTotalPrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="iPayMethod" msprop:Generator_ColumnVarNameInTable="columniPayMethod" msprop:Generator_ColumnPropNameInRow="iPayMethod" msprop:Generator_ColumnPropNameInTable="iPayMethodColumn" msprop:Generator_UserColumnName="iPayMethod" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="iShipType" msprop:Generator_ColumnVarNameInTable="columniShipType" msprop:Generator_ColumnPropNameInRow="iShipType" msprop:Generator_ColumnPropNameInTable="iShipTypeColumn" msprop:Generator_UserColumnName="iShipType" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="iStatus" msprop:Generator_ColumnVarNameInTable="columniStatus" msprop:Generator_ColumnPropNameInRow="iStatus" msprop:Generator_ColumnPropNameInTable="iStatusColumn" msprop:Generator_UserColumnName="iStatus" type="xs:unsignedByte" minOccurs="0" />
              <xs:element name="tDateOfOder" msprop:Generator_ColumnVarNameInTable="columntDateOfOder" msprop:Generator_ColumnPropNameInRow="tDateOfOder" msprop:Generator_ColumnPropNameInTable="tDateOfOderColumn" msprop:Generator_UserColumnName="tDateOfOder" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tDateOfCheck" msprop:Generator_ColumnVarNameInTable="columntDateOfCheck" msprop:Generator_ColumnPropNameInRow="tDateOfCheck" msprop:Generator_ColumnPropNameInTable="tDateOfCheckColumn" msprop:Generator_UserColumnName="tDateOfCheck" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tDateOfShip" msprop:Generator_ColumnVarNameInTable="columntDateOfShip" msprop:Generator_ColumnPropNameInRow="tDateOfShip" msprop:Generator_ColumnPropNameInTable="tDateOfShipColumn" msprop:Generator_UserColumnName="tDateOfShip" type="xs:dateTime" minOccurs="0" />
              <xs:element name="tDateOfClose" msprop:Generator_ColumnVarNameInTable="columntDateOfClose" msprop:Generator_ColumnPropNameInRow="tDateOfClose" msprop:Generator_ColumnPropNameInTable="tDateOfCloseColumn" msprop:Generator_UserColumnName="tDateOfClose" type="xs:dateTime" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
        <xs:element name="tblOrderDetail" msprop:Generator_TableClassName="tblOrderDetailDataTable" msprop:Generator_TableVarName="tabletblOrderDetail" msprop:Generator_TablePropName="tblOrderDetail" msprop:Generator_RowDeletingName="tblOrderDetailRowDeleting" msprop:Generator_UserTableName="tblOrderDetail" msprop:Generator_RowChangingName="tblOrderDetailRowChanging" msprop:Generator_RowEvHandlerName="tblOrderDetailRowChangeEventHandler" msprop:Generator_RowDeletedName="tblOrderDetailRowDeleted" msprop:Generator_RowEvArgName="tblOrderDetailRowChangeEvent" msprop:Generator_RowChangedName="tblOrderDetailRowChanged" msprop:Generator_RowClassName="tblOrderDetailRow">
          <xs:complexType>
            <xs:sequence>
              <xs:element name="FK_iOID" msprop:Generator_ColumnVarNameInTable="columnFK_iOID" msprop:Generator_ColumnPropNameInRow="FK_iOID" msprop:Generator_ColumnPropNameInTable="FK_iOIDColumn" msprop:Generator_UserColumnName="FK_iOID" type="xs:int" />
              <xs:element name="FK_iPID" msprop:Generator_ColumnVarNameInTable="columnFK_iPID" msprop:Generator_ColumnPropNameInRow="FK_iPID" msprop:Generator_ColumnPropNameInTable="FK_iPIDColumn" msprop:Generator_UserColumnName="FK_iPID" type="xs:int" />
              <xs:element name="dPrice" msprop:Generator_ColumnVarNameInTable="columndPrice" msprop:Generator_ColumnPropNameInRow="dPrice" msprop:Generator_ColumnPropNameInTable="dPriceColumn" msprop:Generator_UserColumnName="dPrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="dRealPrice" msprop:Generator_ColumnVarNameInTable="columndRealPrice" msprop:Generator_ColumnPropNameInRow="dRealPrice" msprop:Generator_ColumnPropNameInTable="dRealPriceColumn" msprop:Generator_UserColumnName="dRealPrice" type="xs:decimal" minOccurs="0" />
              <xs:element name="dRealTotal" msprop:Generator_ColumnVarNameInTable="columndRealTotal" msprop:Generator_ColumnPropNameInRow="dRealTotal" msprop:Generator_ColumnPropNameInTable="dRealTotalColumn" msprop:Generator_UserColumnName="dRealTotal" type="xs:decimal" minOccurs="0" />
              <xs:element name="iQuantity" msprop:Generator_ColumnVarNameInTable="columniQuantity" msprop:Generator_ColumnPropNameInRow="iQuantity" msprop:Generator_ColumnPropNameInTable="iQuantityColumn" msprop:Generator_UserColumnName="iQuantity" type="xs:int" minOccurs="0" />
              <xs:element name="iStatus" msprop:Generator_ColumnVarNameInTable="columniStatus" msprop:Generator_ColumnPropNameInRow="iStatus" msprop:Generator_ColumnPropNameInTable="iStatusColumn" msprop:Generator_UserColumnName="iStatus" type="xs:unsignedByte" minOccurs="0" />
            </xs:sequence>
          </xs:complexType>
        </xs:element>
      </xs:choice>
    </xs:complexType>
    <xs:unique name="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblOrder" />
      <xs:field xpath="mstns:PK_iOID" />
    </xs:unique>
    <xs:unique name="tblOrderDetail_Constraint1" msdata:ConstraintName="Constraint1" msdata:PrimaryKey="true">
      <xs:selector xpath=".//mstns:tblOrderDetail" />
      <xs:field xpath="mstns:FK_iOID" />
      <xs:field xpath="mstns:FK_iPID" />
    </xs:unique>
  </xs:element>
</xs:schema>